|
Book details / order |
ORACLE DATABASE 10G: THE COMPLETE REFERENCE |
Description:
get a thorough understanding of oracle database 10g from the most comprehensive oracle database reference on the market, published by oracle press. from critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. upgrade from earlier versions, use sql, sql plus, and pl/sql. get code examples and access popular documentation pdfs--plus a full electronic copy of the book on the included cd-rom. go beyond the basics and learn security, text searches, external tables, using java in oracle, and a great deal more.
table of contents:
part i: critical database concepts
chapter 1: oracle database 10g architecture options
chapter 2: installing oracle database 10g and creating a database
chapter 3: upgrading to oracle database 10g
chapter 4: planning oracle applications?approaches, risks, and standards
part ii: sql and sql*plus
chapter 5: the basic parts of speech in sql
chapter 6: basic sql*plus reports and commands
chapter 7: getting text information and changing it
chapter 8: searching for regular expressions
chapter 9: playing the numbers
chapter 10: dates: then, now, and the difference
chapter 11: conversion and transformation functions
chapter 12: grouping things together
chapter 13: when one query depends upon another
chapter 14: some complex possibilities
chapter 15: changing data insert, update, merge, and delete
chapter 16: decode and case: if, then, and else in sql
chapter 17: creating and managing tables, views, indexes, clusters, and sequences
chapter 18: basic oracle security
part iii: beyond the basics
chapter 19: advanced security?virtual private databases
chapter 20: working with tablespaces
chapter 21: using sql*loader to load data
chapter 22: using data pump export and import
chapter 23: accessing remote data
chapter 24: using materialized views
chapter 25: using oracle text for text searches
chapter 26: using external tables
chapter 27: using flashback queries
chapter 28: flashback?tables and databases
part iv: pl/sql
chapter 29: an introduction to pl/sql
chapter 30: triggers
chapter 31: procedures, functions, and packages
chapter 32: using native dynamic sql and dbms_sql
part v: object-relational databases
chapter 33: implementing types, object views, and methods
chapter 34: collectors (nested tables and varying arrays)
chapter 35: using large objects
chapter 36: advanced object-oriented concepts
part vi: java in oracle
chapter 37: an introduction to java
chapter 38: jdbc programming
chapter 39: java stored procedures
part vii: clustered oracle?the grid
chapter 40: oracle real application clusters
chapter 41: grid architecture and management
part viii: hitchhiker?s guides
chapter 42: the hitchhiker?s guide to the oracle data dictionary
chapter 43: the hitchhiker?s guide to tuning applications and sql
chapter 44: case studies in tuning
chapter 45: the hitchhiker?s guide to oracle application server 10g
chapter 46: the hitchhiker?s guide to database administration
chapter 47: the hitchhiker?s guide to xml in oracle
appendix: alphabetical reference.
Author : Loney, kevin
Publication : Tata
Isbn : 978-0-07-059425-8
Store book number : 106
NRS 1336.00
|
|
|
|
|
|
|
|
|
|